{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["gl. til nyt niveau","reguleringsprocenter","Lønark","Forside","Omregner","Omregningstabel ","Tillæg_trin","Tillæg_kr","Tid op_ned","Samlet_omk"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":75,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"gl. til nyt niveau","index":0,"n_rows":395,"n_cols":6,"rows_kept":395,"cut":false,"hidden":true,"merged":[]}
[null,1.3980790000000001]
[null,null,null,"Nyt grundbeløb","Nyt grundbeløb"]
["Grundbeløb pr. 1/10-1984","I alt pr. 1. april 1999 inkl. %regulering",null,"pr. 31/3-2000","pr. 31/3-2000"]
[null,null,null,"ekskl. afrunding","inkl. afrunding"]
[null,null,null,null,null,"beløb"]
[null,"pr. gang/år","pr. måned",null,null,"+/-"]
[1.63,{"$f":"IF(A7<1000,$B$1*A7,ROUND($B$1*A7,0))","v":2.2788687699999999},null,{"$f":"B7","v":2.2788687699999999},{"$f":"IF(D7<1000,D7,ROUND(D7,-2))","v":2.2788687699999999}]
[5,6.9903950000000004,null,{"$f":"B8","v":6.9903950000000004},6.9903950000000004]
[5.8,8.1088582000000002,null,8.1088582000000002,8.1088582000000002]
[9,12.582711,null,12.582711,12.582711]
[10.5,14.6798295,null,14.6798295,14.6798295]
[12.22,17.084525380000002,null,17.084525380000002,17.084525380000002]
[12.65,17.68569935,null,17.68569935,17.68569935]
[13.39,18.720277810000002,null,18.720277810000002,18.720277810000002]
[13.75,19.22358625,null,19.22358625,19.22358625]
[14.46,20.216222340000002,null,20.216222340000002,20.216222340000002]
[15.2,21.2508008,null,21.2508008,21.2508008]
[15.5,21.6702245,null,21.6702245,21.6702245]
[17,23.767343,null,23.767343,23.767343]
[18.5,25.864461500000001,null,25.864461500000001,25.864461500000001]
[19,26.563501000000002,null,26.563501000000002,26.563501000000002]
[21,29.359659000000001,null,29.359659000000001,29.359659000000001]
[23,32.155816999999999,null,32.155816999999999,32.155816999999999]
[24.97,34.910032630000003,null,34.910032630000003,34.910032630000003]
[28,39.146212000000006,null,39.146212000000006,39.146212000000006]
[30,41.942370000000004,null,41.942370000000004,41.942370000000004]
[33.29,46.542049910000003,null,46.542049910000003,46.542049910000003]
[42,58.719318000000001,null,58.719318000000001,58.719318000000001]
[61.26,85.646319540000007,null,85.646319540000007,85.646319540000007]
[62,86.680897999999999,null,86.680897999999999,86.680897999999999]
[68.319999999999993,95.516757279999993,null,95.516757279999993,95.516757279999993]
[75.13,105.03767526999999,null,105.03767526999999,105.03767526999999]
[80.38,112.37759002,null,112.37759002,112.37759002]
[136.63999999999999,191.03351455999999,null,{"$f":"B34","v":191.03351455999999},191.03351455999999]
[143.99,201.30939521000002,null,{"$f":"B35","v":201.30939521000002},201.30939521000002]
[150.61000000000001,210.56467819000002,null,210.56467819000002,210.56467819000002]
[164,229.28495600000002,null,229.28495600000002,229.28495600000002]
[170,237.67343000000002,null,237.67343000000002,237.67343000000002]
[190,265.63501000000002,null,265.63501000000002,{"$f":"IF(D39<1000,D39,ROUND(D39,-2))","v":265.63501000000002}]
[195,272.625405,null,272.625405,272.625405]
[202,282.41195800000003,null,282.41195800000003,282.41195800000003]
[260,363.50054,null,363.50054,363.50054]
[278,388.66596200000004,null,388.66596200000004,388.66596200000004]
[300.83999999999997,420.59808635999997,null,420.59808635999997,420.59808635999997]
[350,489.32765000000001,null,489.32765000000001,489.32765000000001]
[380,531.27002000000005,null,531.27002000000005,531.27002000000005]
[398.95,557.76361704999999,null,557.76361704999999,557.76361704999999]
[420,587.19317999999998,null,587.19317999999998,587.19317999999998]
[465,650.10673500000007,null,650.10673500000007,650.10673500000007]
[490,685.05871000000002,null,685.05871000000002,685.05871000000002]
[502,701.83565800000008,null,701.83565800000008,701.83565800000008]
[559,781.526161,null,781.526161,781.526161]
[597,834.65316300000006,null,834.65316300000006,834.65316300000006]
[700,978.65530000000001,{"$f":"VALUE(B54)/12","v":81.554608333333334},978.65530000000001,{"$f":"IF(D54<1000,D54,ROUND(D54,-2))","v":978.65530000000001},{"$f":"E54-D54","v":0}]
[750,1048.55925,87.379937499999997,1048.55925,{"$f":"IF(D55<1000,D55,ROUND(D55,-2))","v":1000},-48.55925000000002]
[800,1118.4632000000001,93.205266666666674,1118.4632000000001,{"$f":"IF(D56<1000,D56,ROUND(D56,-2))","v":1100},-18.463200000000143]
[842.75,1178.23107725,98.185923104166662,1178.23107725,1200,21.768922750000002]
[868,1213.5325720000001,101.12771433333334,1213.5325720000001,1200,-13.532572000000073]
[917.14,1282.23417406,106.85284783833333,{"$f":"B59","v":1282.23417406},1300,17.765825940000013]
[920,1286.2326800000001,107.18605666666667,1286.2326800000001,1300,13.767319999999927]
[925,1293.2230750000001,107.76858958333334,1293.2230750000001,1300,6.776924999999892]
[950,{"$f":"IF(A62<1000,$B$1*A62,ROUND($B$1*A62,0))","v":1328.1750500000001},110.68125416666668,1328.1750500000001,1300,-28.175050000000056]
[1000,{"$f":"IF(A63<1000,$B$1*A63,ROUND($B$1*A63,0))","v":1398},116.5,1398,1400,2]
[1050,{"$f":"IF(A64<1000,$B$1*A64,ROUND($B$1*A64,0))","v":1468},122.33333333333333,1468,1500,32]
[1100,{"$f":"IF(A65<1000,$B$1*A65,ROUND($B$1*A65,0))","v":1538},128.16666666666666,1538,1500,-38]
[1200,1678,139.83333333333334,1678,1700,22]
[1245,1741,145.08333333333334,{"$f":"B67","v":1741},1700,{"$f":"E67-D67","v":-41}]
[1300,1818,151.5,1818,1800,-18]
[1327,1855,154.58333333333334,1855,1900,45]
[1400,1957,163.08333333333334,1957,2000,43]
[1500,2097,174.75,2097,2100,3]
[1600,2237,186.41666666666666,2237,2200,-37]
[1700,2377,198.08333333333334,2377,2400,23]
[1750,2447,203.91666666666666,2447,2400,-47]
[1800,2517,209.75,2517,2500,-17]
[1900,2656,221.33333333333334,2656,2700,44]
[2000,2796,233,2796,2800,4]
[2050,2866,238.83333333333334,2866,2900,34]
[2100,2936,244.66666666666666,2936,2900,-36]
[2145,2999,249.91666666666666,2999,3000,1]
[2150,3006,250.5,3006,3000,-6]
[2200,3076,256.33333333333331,3076,3100,24]
[2300,3216,268,3216,3200,-16]
[2400,3355,279.58333333333331,3355,3400,45]
[2450,3425,285.41666666666669,3425,3400,-25]
[2500,3495,291.25,3495,3500,5]
[2600,3635,302.91666666666669,3635,3600,-35]
[2700,3775,314.58333333333331,3775,3800,25]
[2730,3817,318.08333333333331,3817,3800,-17]
[2800,3915,326.25,3915,3900,-15]
[2900,4054,337.83333333333331,4054,4100,46]
[3000,4194,349.5,4194,4200,6]
[3100,4334,361.16666666666669,4334,4300,-34]
[3200,4474,372.83333333333331,4474,4500,26]
[3300,4614,384.5,4614,4600,-14]
[3400,4753,396.08333333333331,4753,4800,47]
[3500,4893,407.75,4893,4900,7]
[3600,5033,419.41666666666669,5033,5000,-33]
[3700,5173,431.08333333333331,5173,5200,27]
[3800,5313,442.75,5313,5300,-13]
[3900,5453,454.41666666666669,5453,5500,47]
[4000,5592,466,5592,5600,8]
[4100,5732,477.66666666666669,5732,5700,-32]
[4200,5872,489.33333333333331,5872,5900,28]
[4226.1000000000004,5908,492.33333333333331,5908,5900,-8]
[4300,6012,501,6012,6000,-12]
[4400,6152,512.66666666666663,6152,6200,48]
[4430,6193,516.08333333333337,6193,6200,7]
[4500,6291,524.25,6291,6300,9]
[4600,6431,535.91666666666663,6431,6400,-31]
[4700,6571,547.58333333333337,6571,6600,29]
[1770,2475,206.25,2475,2500,25]
[4800,6711,559.25,6711,6700,-11]
[4900,6851,570.91666666666663,6851,6900,49]
[4930,6893,574.41666666666663,6893,6900,7]
[5000,6990,582.5,6990,7000,10]
[5100,7130,594.16666666666663,7130,7100,-30]
[5200,7270,{"$f":"VALUE(B118)/12","v":605.83333333333337},7270,7300,30]
[5300,7410,617.5,7410,7400,-10]
[5318,7435,619.58333333333337,7435,{"$f":"IF(D120<1000,D120,ROUND(D120,-2))","v":7400},-35]
[5400,7550,629.16666666666663,7550,7600,50]
[5420.91,7579,631.58333333333337,7579,7600,21]
[5500,7689,640.75,{"$f":"B123","v":7689},7700,{"$f":"E123-D123","v":11}]
[5600,7829,652.41666666666663,7829,7800,-29]
[5700,7969,664.08333333333337,7969,8000,31]
[5770.78,8068,672.33333333333337,8068,8100,32]
[5800,8109,675.75,8109,8100,-9]
[5900,8249,687.41666666666663,8249,8200,-49]
[6000,{"$f":"IF(A129<1000,$B$1*A129,ROUND($B$1*A129,0))","v":8388},699,8388,8400,12]
[6078,8498,708.16666666666663,8498,8500,2]
[6100,8528,710.66666666666663,8528,8500,-28]
[6140,8584,715.33333333333337,8584,8600,16]
[6200,8668,722.33333333333337,8668,8700,32]
[6290.15,8794,732.83333333333337,8794,8800,6]
[6300,8808,734,8808,8800,-8]
[6400,8948,745.66666666666663,8948,8900,-48]
[6500,9088,757.33333333333337,9088,9100,12]
[6600,9227,768.91666666666663,9227,9200,-27]
[6700,9367,780.58333333333337,9367,9400,33]
[6743.33,9428,785.66666666666663,9428,9400,-28]
[6800,9507,792.25,9507,9500,-7]
[6900,9647,803.91666666666663,9647,9600,-47]
[7000,9787,815.58333333333337,9787,9800,13]
[7100,9926,827.16666666666663,9926,9900,-26]
[7200,10066,838.83333333333337,10066,10100,34]
[7300,10206,850.5,10206,10200,-6]
[7335.23,10255,854.58333333333337,10255,10300,45]
[7400,10346,862.16666666666663,10346,10300,-46]
[7500,10486,873.83333333333337,10486,10500,14]
[7600,10625,885.41666666666663,10625,10600,-25]
[7700,10765,897.08333333333337,10765,10800,35]
[7800,10905,908.75,10905,10900,-5]
[7900,11045,920.41666666666663,11045,11000,-45]
[8000,11185,932.08333333333337,11185,11200,15]
[8100,11324,943.66666666666663,11324,11300,-24]
[8200,11464,955.33333333333337,11464,11500,36]
[8300,11604,967,11604,11600,-4]
[8400,11744,978.66666666666663,11744,11700,-44]
[8500,11884,990.33333333333337,11884,11900,16]
[8600,12023,1001.9166666666666,12023,12000,-23]
[8700,12163,1013.5833333333334,12163,12200,37]
[8800,12303,1025.25,12303,12300,-3]
[8900,12443,1036.9166666666667,12443,12400,-43]
[9000,12583,1048.5833333333333,12583,12600,17]
[9100,12723,1060.25,12723,12700,-23]
[9200,12862,1071.8333333333333,12862,12900,38]
[9300,13002,1083.5,13002,13000,-2]
[9400,13142,1095.1666666666667,13142,13100,-42]
[9450,13212,1101,13212,13200,-12]
[9500,13282,1106.8333333333333,13282,13300,18]
[9600,13422,1118.5,13422,13400,-22]
[9700,13561,1130.0833333333333,13561,13600,39]
[9800,13701,1141.75,13701,13700,-1]
[9900,13841,1153.4166666666667,13841,13800,-41]
[10000,13981,1165.0833333333333,13981,14000,19]
[10600,14820,1235,14820,14800,-20]
[10800,15099,1258.25,15099,15100,1]
[11000,15379,1281.5833333333333,15379,15400,21]
[11200,15658,1304.8333333333333,15658,15700,42]
[11300,15798,1316.5,15798,15800,2]
[11500,16078,1339.8333333333333,16078,16100,22]
[11600,16218,{"$f":"VALUE(B182)/12","v":1351.5},16218,16200,-18]
[11700,16358,1363.1666666666667,16358,16400,42]
[11800,16497,1374.75,16497,{"$f":"IF(D184<1000,D184,ROUND(D184,-2))","v":16500},3]
[11900,16637,1386.4166666666667,16637,16600,-37]
[12000,16777,1398.0833333333333,16777,16800,23]
[12100,16917,1409.75,{"$f":"B187","v":16917},16900,{"$f":"E187-D187","v":-17}]
[12200,17057,1421.4166666666667,17057,17100,43]
[12300,17196,1433,17196,17200,4]
[12400,17336,1444.6666666666667,17336,17300,-36]
[12500,17476,1456.3333333333333,17476,17500,24]
[12600,17616,1468,17616,17600,-16]
[12700,{"$f":"IF(A193<1000,$B$1*A193,ROUND($B$1*A193,0))","v":17756},1479.6666666666667,17756,17800,44]
[12800,17895,1491.25,17895,17900,5]
[12900,18035,1502.9166666666667,18035,18000,-35]
[13000,18175,1514.5833333333333,18175,18200,25]
[13200,18455,1537.9166666666667,18455,18500,45]
[13400,18734,1561.1666666666667,18734,18700,-34]
[13500,18874,1572.8333333333333,18874,18900,26]
[13700,19154,1596.1666666666667,19154,19200,46]
[14000,19573,1631.0833333333333,19573,19600,27]
[14300,19993,1666.0833333333333,19993,20000,7]
[14500,20272,1689.3333333333333,20272,20300,28]
[14700,20552,1712.6666666666667,20552,20600,48]
[14800,20692,1724.3333333333333,20692,20700,8]
[14900,20831,1735.9166666666667,20831,20800,-31]
[15000,20971,1747.5833333333333,20971,21000,29]
[15100,21111,1759.25,21111,21100,-11]
[15200,21251,1770.9166666666667,21251,21300,49]
[15500,21670,1805.8333333333333,21670,21700,30]
[15700,21950,1829.1666666666667,21950,22000,50]
[15900,22229,1852.4166666666667,22229,22200,-29]
[16000,22369,1864.0833333333333,22369,22400,31]
[16100,22509,1875.75,22509,22500,-9]
[16200,22649,1887.4166666666667,22649,22600,-49]
[16700,23348,1945.6666666666667,23348,23300,-48]
[16800,23488,1957.3333333333333,23488,23500,12]
[16900,23628,1969,23628,23600,-28]
[17000,23767,1980.5833333333333,23767,23800,33]
[17100,23907,1992.25,23907,23900,-7]
[17600,24606,2050.5,24606,24600,-6]
[17700,24746,2062.1666666666665,24746,24700,-46]
[18000,25165,2097.0833333333335,25165,25200,35]
[18200,25445,2120.4166666666665,25445,25400,-45]
[18300,25585,2132.0833333333335,25585,25600,15]
[18600,26004,2167,26004,26000,-4]
[18700,26144,2178.6666666666665,26144,26100,-44]
[18800,26284,2190.3333333333335,{"$f":"B228","v":26284},26300,{"$f":"E228-D228","v":16}]
[18900,26424,2202,26424,26400,-24]
[19000,26564,2213.6666666666665,26564,26600,36]
[19100,26703,2225.25,26703,26700,-3]
[19400,27123,2260.25,27123,27100,-23]
[19500,27263,2271.9166666666665,27263,27300,37]
[19600,27402,2283.5,27402,27400,-2]
[19700,27542,2295.1666666666665,27542,27500,-42]
[20000,27962,2330.1666666666665,27962,28000,38]
[20300,28381,2365.0833333333335,28381,28400,19]
[20400,28521,2376.75,28521,28500,-21]
[20500,28661,2388.4166666666665,28661,28700,39]
[20800,29080,2423.3333333333335,29080,29100,20]
[20900,29220,2435,29220,29200,-20]
[21100,29499,2458.25,29499,29500,1]
[21300,29779,2481.5833333333335,29779,29800,21]
[21900,30618,2551.5,30618,30600,-18]
[22000,30758,2563.1666666666665,30758,30800,42]
[22200,31037,{"$f":"VALUE(B246)/12","v":2586.4166666666665},31037,31000,-37]
[22400,31317,2609.75,31317,31300,-17]
[22500,31457,2621.4166666666665,31457,{"$f":"IF(D248<1000,D248,ROUND(D248,-2))","v":31500},43]
[22600,31597,2633.0833333333335,31597,31600,3]
[22900,32016,2668,32016,32000,-16]
[23000,32156,2679.6666666666665,32156,32200,44]
[23200,32435,2702.9166666666665,32435,32400,-35]
[23300,32575,2714.5833333333335,32575,32600,25]
[23400,32715,2726.25,32715,32700,-15]
[23500,32855,2737.9166666666665,32855,32900,45]
[23600,32995,2749.5833333333335,32995,33000,5]
[23700,{"$f":"IF(A257<1000,$B$1*A257,ROUND($B$1*A257,0))","v":33134},2761.1666666666665,33134,33100,-34]
[23800,33274,2772.8333333333335,33274,33300,26]
[23900,33414,2784.5,33414,33400,-14]
[24000,33554,2796.1666666666665,33554,33600,46]
[24500,34253,2854.4166666666665,34253,34300,47]
[24900,34812,2901,34812,34800,-12]
[25000,34952,2912.6666666666665,34952,35000,48]
[25200,35232,2936,35232,35200,-32]
[25400,35511,2959.25,35511,35500,-11]
[25700,35931,2994.25,35931,35900,-31]
[26000,36350,3029.1666666666665,36350,36400,50]
[26300,36769,3064.0833333333335,36769,36800,31]
[26600,37189,3099.0833333333335,37189,37200,11]
[26700,37329,3110.75,37329,37300,-29]
[26900,37608,3134,37608,37600,-8]
[27000,37748,3145.6666666666665,37748,37700,-48]
[27100,37888,3157.3333333333335,37888,37900,12]
[27600,38587,3215.5833333333335,38587,38600,13]
[27700,38727,3227.25,38727,38700,-27]
[28000,39146,3262.1666666666665,39146,39100,-46]
[28100,39286,3273.8333333333335,39286,39300,14]
[29000,40544,3378.6666666666665,40544,40500,-44]
[29100,40684,3390.3333333333335,40684,40700,16]
[29200,40824,3402,40824,40800,-24]
[29300,40964,3413.6666666666665,40964,41000,36]
[29400,41104,3425.3333333333335,41104,41100,-4]
[29900,41803,3483.5833333333335,41803,41800,-3]
[30000,41942,3495.1666666666665,41942,41900,-42]
[30200,42222,3518.5,42222,42200,-22]
[30500,42641,3553.4166666666665,42641,42600,-41]
[30700,42921,3576.75,42921,42900,-21]
[30800,43061,3588.4166666666665,43061,43100,39]
[31800,44459,3704.9166666666665,44459,44500,41]
[32000,44739,3728.25,44739,44700,-39]
[32100,44878,3739.8333333333335,44878,44900,22]
[32500,45438,3786.5,{"$f":"B292","v":45438},45400,{"$f":"E292-D292","v":-38}]
[33000,46137,3844.75,46137,46100,-37]
[33300,46556,3879.6666666666665,46556,46600,44]
[34200,47814,3984.5,47814,47800,-14]
[34300,47954,3996.1666666666665,47954,48000,46]
[34700,48513,4042.75,48513,48500,-13]
[35000,48933,4077.75,{"$f":"B298","v":48933},48900,{"$f":"E298-D298","v":-33}]
[35100,49073,4089.4166666666665,49073,49100,27]
[35200,49212,4101,49212,49200,-12]
[35400,49492,4124.333333333333,49492,49500,8]
[36500,51030,4252.5,51030,51000,-30]
[36700,51309,4275.75,51309,51300,-9]
[37000,51729,4310.75,51729,51700,-29]
[38200,53407,4450.583333333333,53407,53400,-7]
[38900,54385,4532.083333333333,54385,54400,15]
[39200,54805,4567.083333333333,54805,54800,-5]
[40300,56343,4695.25,56343,56300,-43]
[40900,57181,4765.083333333333,57181,57200,19]
[41600,58160,{"$f":"VALUE(B310)/12","v":4846.666666666667},58160,58200,40]
[42000,58719,4893.25,58719,58700,-19]
[42700,59698,4974.833333333333,59698,{"$f":"IF(D312<1000,D312,ROUND(D312,-2))","v":59700},2]
[43300,60537,5044.75,60537,60500,-37]
[43500,60816,5068,60816,60800,-16]
[44000,61515,5126.25,61515,61500,-15]
[44100,61655,5137.916666666667,61655,61700,45]
[44900,62774,5231.166666666667,62774,62800,26]
[45700,63892,5324.333333333333,63892,63900,8]
[46000,64312,5359.333333333333,64312,64300,-12]
[46500,65011,5417.583333333333,65011,65000,-11]
[47000,{"$f":"IF(A321<1000,$B$1*A321,ROUND($B$1*A321,0))","v":65710},5475.833333333333,65710,65700,-10]
[47200,65989,5499.083333333333,65989,66000,11]
[47700,66688,5557.333333333333,66688,66700,12]
[48000,67108,5592.333333333333,67108,67100,-8]
[48600,67947,5662.25,67947,67900,-47]
[48800,68226,5685.5,68226,68200,-26]
[49900,69764,5813.666666666667,69764,69800,36]
[50000,69904,5825.333333333333,69904,69900,-4]
[51300,71721,5976.75,71721,71700,-21]
[52000,72700,6058.333333333333,72700,72700,0]
[53000,74098,6174.833333333333,74098,74100,2]
[53900,75356,6279.666666666667,75356,75400,44]
[55000,76894,6407.833333333333,76894,76900,6]
[56700,79271,6605.916666666667,79271,79300,29]
[56800,79411,6617.583333333333,79411,79400,-11]
[57000,79691,6640.916666666667,79691,79700,9]
[58700,82067,6838.916666666667,82067,82100,33]
[58800,82207,6850.583333333333,82207,82200,-7]
[59000,82487,6873.916666666667,82487,82500,13]
[59900,83745,6978.75,83745,83700,-45]
[60000,83885,6990.416666666667,83885,83900,15]
[62300,87100,7258.333333333333,87100,87100,0]
[63000,88079,7339.916666666667,88079,88100,21]
[63300,88498,7374.833333333333,88498,88500,2]
[63700,89058,7421.5,89058,89100,42]
[65000,90875,7572.916666666667,90875,90900,25]
[66100,92413,7701.083333333333,92413,92400,-13]
[67000,93671,7805.916666666667,93671,93700,29]
[69600,97306,8108.833333333333,97306,97300,-6]
[70400,98425,8202.0833333333339,98425,98400,-25]
[70800,98984,8248.6666666666661,98984,99000,16]
[71000,99264,8272,99264,99300,36]
[71700,100242,8353.5,100242,100200,-42]
[73400,102619,8551.5833333333339,102619,102600,-19]
[73500,102759,8563.25,102759,102800,41]
[78900,110308,9192.3333333333339,110308,110300,-8]
[80600,112685,9390.4166666666661,112685,112700,15]
[82200,114922,9576.8333333333339,114922,114900,-22]
[82600,115481,9623.4166666666661,115481,115500,19]
[82900,115901,9658.4166666666661,115901,115900,-1]
[83300,116460,9705,116460,116500,40]
[87000,121633,10136.083333333334,{"$f":"B362","v":121633},121600,{"$f":"E362-D362","v":-33}]
[88100,123171,10264.25,123171,123200,29]
[90600,126666,10555.5,126666,126700,34]
[93200,130301,10858.416666666666,130301,130300,-1]
[93900,131280,10940,131280,131300,20]
[94400,131979,10998.25,131979,132000,21]
[95300,133237,11103.083333333334,133237,133200,-37]
[96200,134495,11207.916666666666,134495,134500,5]
[102700,143583,11965.25,143583,143600,17]
[102800,143723,11976.916666666666,143723,143700,-23]
[104100,145540,12128.333333333334,145540,145500,-40]
[105600,147637,12303.083333333334,147637,147600,-37]
[106100,148336,{"$f":"VALUE(B374)/12","v":12361.333333333334},148336,148300,-36]
[109400,152950,12745.833333333334,152950,153000,50]
[110000,153789,12815.75,153789,{"$f":"IF(D376<1000,D376,ROUND(D376,-2))","v":153800},11]
[116200,162457,13538.083333333334,162457,162500,43]
[117300,163995,13666.25,163995,164000,5]
[117400,164134,13677.833333333334,164134,164100,-34]
[118000,164973,13747.75,164973,165000,27]
[118300,165393,13782.75,165393,165400,7]
[123400,172523,14376.916666666666,172523,172500,-23]
[124700,174340,14528.333333333334,174340,174300,-40]
[127100,177696,14808,177696,177700,4]
[129100,{"$f":"IF(A385<1000,$B$1*A385,ROUND($B$1*A385,0))","v":180492},15041,180492,180500,8]
[129800,181471,15122.583333333334,181471,181500,29]
[130900,183009,15250.75,183009,183000,-9]
[131900,184407,15367.25,184407,184400,-7]
[133400,186504,15542,186504,186500,-4]
[139400,194892,16241,194892,194900,8]
[140900,196989,16415.75,196989,197000,11]
[141600,197968,16497.333333333332,197968,198000,32]
[145000,202721,16893.416666666668,202721,202700,-21]
[146600,204958,17079.833333333332,204958,205000,42]
[147700,206496,17208,206496,206500,4]

{"sheet":"reguleringsprocenter","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Reguleringsprocenter",null,"pensionsudbygning"]
[null,"Valgt:",{"$f":"VLOOKUP(Forside!K11,reguleringsprocenter!B4:D15,2,TRUE)","v":1.5981590000000001}]
[null,"2020-01-01",1.4124110000000001,1]
[null,"2020-04-01",1.4177979999999999,1]
[null,"2020-10-01",1.4285110000000001,1]
[null,"2021-04-01",1.442796,1]
[null,"2021-10-01",1.456933,1]
[null,"2022-04-01",1.456933,1]
[null,"2022-10-01",1.4940180000000001,1]
[null,"2023-04-01",1.4983040000000001,1]
[null,"2023-10-01",1.5169710000000001,1]
[null,"2024-04-01",1.57765,1]
[null,"2024-10-01",1.5981590000000001,1]
[]
[]
[]
[null,"Liste, opslag niveauer"]
[]
[null,"2024-10-01"]
[null,"2024-04-01"]
[null,"2023-10-01"]
[null,"2023-04-01"]
[null,"2022-10-01"]
[null,"2022-04-01"]
[null,"2021-10-01"]
[null,"2021-04-01"]
[null,"2020-10-01"]
[null,"2020-04-01"]

{"sheet":"Lønark","index":2,"n_rows":71,"n_cols":88,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
["Næstved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,"Årsløn ialt ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lavtlønsprojekt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,null,null,null,null,null,null,"Områdetillæg inkl. regulering",null,null,null,null,"Årsløn ialt ",null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Løn","timelønninger",null,null,null,null,null,"Løn","timelønninger + 50%",null,null,null,null,null,"Løn","søndagstillæg - 50%",null,null,null,null,null,null,"2019-03-31",0,0]
[null,"Månedsløn, løngrupper",null,null,"Lønniveau:",{"$f":"VLOOKUP(beregningsdato,regpct_tabel,1,TRUE)","v":"2024-10-01"},null,"Optrapning fra:",null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Pensionsgivende løn, optrapning fra:",null,null,null,null,"trin","Grundsats","%-reg.","Sats","Omr 1","Omr 2","Omr 3","Omr 4",null,null,null,null,null,null,1,2,3,4,null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"Grundsats","%-reg.","Sats",null,"Pensionsudbygningspct:",null,null,{"$f":"VLOOKUP(F4,regpct_tabel,3,FALSE)","v":1},null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,null,"2019-04-01",382,0]
[null,0,1,2,3,4,null,"0->1","1->2","2->3",null,null,0,1,2,3,4,null,"0->1","1->2","2->3","3->4",null,null,{"$f":"VLOOKUP(beregningsdato,Lavtløn,2,TRUE)","v":1035},{"$f":"valgt_regulering-1","v":0.59815900000000011},"2019-04-01","2022-04-01",{"$f":"VLOOKUP(beregningsdato,Lavtløn,3,TRUE)","v":653},null,null,null,null,null,null,null,null,{"$f":"IF(beregningsdato<40087,0,regulering)","v":0.59815900000000011},{"$f":"IF(beregningsdato<40087,0,5)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",{"$f":"CI4+CJ5","v":1035},653]
[1,{"$f":"AQ6/12","v":19603.25},19880.5,20072.416666666668,20349.833333333332,20541.75,null,{"$f":"ROUND(AQ6+(AR6-AQ6)/3*faktor,0)/12","v":22982557.25},{"$f":"ROUND(AR6+(AS6-AR6)/3*faktor,0)/12","v":15915186.5},{"$f":"ROUND(AS6+(AT6-AS6)/3*faktor,0)/12","v":22996830.416666668},null,1,{"$f":"BF6/12","v":19603.25},19880.5,20072.416666666668,20349.833333333332,20541.75,null,{"$f":"(BF6+ROUND((BG6-BF6)/3*faktor,0))/12","v":22982557.25},{"$f":"(BG6+ROUND((BH6-BG6)/3*faktor,0))/12","v":15915186.5},{"$f":"(BH6+ROUND((BI6-BH6)/3*faktor,0))/12","v":22996830.416666668},{"$f":"(BI6+ROUND((BJ6-BI6)/3*faktor,0))/12","v":15915655.833333334},null,1,147194,{"$f":"ROUND(Y6*regulering,0)","v":88045},{"$f":"Y6+Z6","v":235239},2585,4374,6959,8748,null,2082,3523,5606,7047,null,{"$f":"ROUND(VLOOKUP($X6,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":3327},5630,8959,11262,null,{"$f":"$AA6","v":235239},{"$f":"$AA6+AL6","v":238566},240869,244198,246501,null,147194,{"$f":"AW6*regulering","v":88045.415846000018},{"$f":"ROUND(SUM(AW6:AX6),0)","v":235239},null,{"$f":"ROUND(AL6*udbygningspct,0)","v":3327},{"$f":"ROUND(AM6*udbygningspct,0)","v":5630},{"$f":"ROUND(AN6*udbygningspct,0)","v":8959},{"$f":"ROUND(AO6*udbygningspct,0)","v":11262},null,{"$f":"AY6","v":235239},{"$f":"$BF6+BA6","v":238566},{"$f":"$BF6+BB6","v":240869},244198,246501,null,1,{"$f":"AQ6/1924","v":122.26559251559252},123.9948024948025,125.19178794178794,126.92203742203742,128.11902286902287,null,1,{"$f":"AQ6/1924*1.5","v":183.39838877338877},{"$f":"AR6/1924*1.5","v":185.99220374220374},{"$f":"AS6/1924*1.5","v":187.7876819126819},{"$f":"AT6/1924*1.5","v":190.38305613305613},{"$f":"AU6/1924*1.5","v":192.17853430353432},null,1,{"$f":"AQ6/1924/2","v":61.132796257796258},61.99740124740125,62.595893970893968,63.46101871101871,64.059511434511435]
[2,19904.416666666668,20188.5,20385.083333333332,20669.166666666668,20865.75,null,23548822.416666668,16302006.5,23549303.083333332,null,2,19904.416666666668,20188.5,20385.083333333332,20669.166666666668,20865.75,null,23548822.416666668,16302006.5,23549303.083333332,16302487.166666666,null,2,149455,89398,238853,2648,4481,7128,8961,null,2133,3609,5742,7218,null,3409,5768,9177,11536,null,{"$f":"$AA7","v":238853},242262,244621,248030,250389,null,149455,{"$f":"AW7*regulering","v":89397.85334500001},{"$f":"ROUND(SUM(AW7:AX7),0)","v":238853},null,3409,5768,9177,11536,null,{"$f":"AY7","v":238853},242262,244621,248030,250389,null,2,124.14397089397089,125.91580041580042,127.14189189189189,128.91372141372142,130.1398128898129,null,2,{"$f":"AQ7/1924*1.5","v":186.21595634095632},188.87370062370064,190.71283783783784,193.37058212058213,195.20971933471935,null,2,62.071985446985444,62.957900207900209,63.570945945945944,64.456860706860709,65.069906444906451]
[3,20213.666666666668,20504.5,20706,20996.916666666668,21198.5,null,24108193.666666668,16709540.5,24115588,null,3,20213.666666666668,20504.5,20706,20996.916666666668,21198.5,null,24108193.666666668,16709540.5,24115588,16716934.916666666,null,3,151777,90787,242564,2711,4590,7301,9180,null,2184,3697,5881,7395,null,3490,5908,9399,11818,null,242564,246054,248472,251963,254382,null,151777,90786.778543000022,242564,null,3490,5908,9399,11818,null,242564,246054,248472,251963,254382,null,3,126.07276507276508,127.88669438669439,129.14345114345113,130.9579002079002,132.21517671517671,null,3,189.10914760914761,191.83004158004158,193.71517671517671,196.43685031185029,198.32276507276507,null,3,63.03638253638254,63.943347193347194,64.571725571725565,65.478950103950098,66.107588357588355]
[4,20531.416666666668,20829.583333333332,21035.916666666668,21334.083333333332,21540.416666666668,null,24715887.416666668,17110181.583333332,24716391.916666668,null,4,20531.416666666668,20829.583333333332,21035.916666666668,21334.083333333332,21540.416666666668,null,24715887.416666668,17110181.583333332,24716391.916666668,17110686.083333332,null,4,154163,92214,246377,2779,4703,7482,9405,null,2239,3788,6027,7576,null,3578,6054,9632,12108,null,246377,249955,252431,256009,258485,null,154163,92213.985917000013,246377,null,3578,6054,9632,12108,null,246377,249955,252431,256009,258485,null,4,128.05457380457381,129.91424116424116,131.20114345114345,133.06081081081081,134.3477130977131,null,4,192.08186070686071,194.87136174636174,196.80171517671516,199.5912162162162,201.52156964656965,null,4,64.027286902286903,64.957120582120581,65.600571725571726,66.530405405405403,67.173856548856548]
[5,20857.833333333332,21163.25,21374.833333333332,21680.25,21891.583333333332,null,25316687.833333332,17545341.25,25317204.833333332,null,5,20857.833333333332,21163.25,21374.833333333332,21680.25,21891.583333333332,null,25316687.833333332,17545341.25,25317204.833333332,17525152.25,null,5,156614,93680,250294,2847,4819,7666,9636,null,2293,3882,6175,7762,null,3665,6204,9869,12405,null,250294,253959,256498,260163,262699,null,156614,93680.073626000012,250294,null,3665,6204,9869,12405,null,250294,253959,256498,260163,262699,null,5,130.09043659043658,131.99532224532226,133.31496881496881,135.21985446985448,136.53794178794178,null,5,195.13565488565487,197.99298336798338,199.97245322245323,202.82978170478174,204.80691268191265,null,5,65.045218295218291,65.997661122661128,66.657484407484404,67.609927234927241,68.268970893970888]
[6,21193.583333333332,21506.583333333332,21723.25,22036.083333333332,22252.75,null,25945105.583333332,17966706.583333332,25931831.25,null,6,21193.583333333332,21506.583333333332,21723.25,22036.083333333332,22252.75,null,25945105.583333332,17966706.583333332,25931831.25,17967236.083333332,null,6,159135,95188,254323,2917,4937,7854,9873,null,2350,3977,6326,7953,null,3756,6356,10110,12710,null,254323,258079,260679,264433,267033,null,159135,95188.032465000011,254323,null,3756,6356,10110,12710,null,254323,258079,260679,264433,267033,null,6,132.18451143451142,134.13669438669439,135.48804573804574,137.43918918918919,138.79054054054055,null,6,198.27676715176713,201.20504158004158,203.23206860706861,206.1587837837838,208.18581081081084,null,6,66.092255717255711,67.068347193347194,67.744022869022871,68.719594594594597,69.395270270270274]
[7,21538,21858.666666666668,22080.833333333332,22401.5,22623.416666666668,null,26580434,18422590.666666668,26580976.833333332,null,7,21538,21858.666666666668,22080.833333333332,22401.5,22623.416666666668,null,26580434,18422590.666666668,26580976.833333332,18402427.5,null,7,161721,96735,258456,2989,5060,8049,10118,null,2408,4076,6484,8150,null,3848,6514,10362,13025,null,258456,262304,264970,268818,271481,null,161721,96734.871639000019,258456,null,3848,6514,10362,13025,null,258456,262304,264970,268818,271481,null,7,134.33264033264032,136.33264033264032,137.71829521829522,139.71829521829522,141.10239085239084,null,7,201.49896049896049,204.49896049896049,206.57744282744284,209.57744282744284,211.65358627858626,null,7,67.166320166320162,68.166320166320162,68.859147609147612,69.859147609147612,70.55119542619542]
[8,21905,22233.916666666668,22461.833333333332,22790.666666666668,23018.416666666668,null,27264099,18899203.916666668,27257753.833333332,null,8,21905,22233.916666666668,22461.833333333332,22790.666666666668,23018.416666666668,null,27264099,18899203.916666668,27257753.833333332,18885956.666666668,null,8,164477,98383,262860,3067,5190,8256,10379,null,2470,4181,6650,8360,null,3947,6682,10628,13361,null,262860,266807,269542,273488,276221,null,164477,98383.397843000013,262860,null,3947,6682,10628,13361,null,262860,266807,269542,273488,276221,null,8,136.62162162162161,138.67307692307693,140.09459459459458,142.14553014553016,143.56600831600832,null,8,204.93243243243242,208.00961538461542,210.14189189189187,213.21829521829522,215.34901247401248,null,8,68.310810810810807,69.336538461538467,70.047297297297291,71.07276507276508,71.783004158004161]
[9,22594.083333333332,22931.333333333332,23164.666666666668,23501.666666666668,23735.166666666668,null,{"$f":"ROUND(AQ14+(AR14-AQ14)/3*faktor,0)/12","v":27954988.083333332},{"$f":"ROUND(AR14+(AS14-AR14)/3*faktor,0)/12","v":19348531.333333332},{"$f":"ROUND(AS14+(AT14-AS14)/3*faktor,0)/12","v":27934852.666666668},null,9,22594.083333333332,22931.333333333332,23164.666666666668,23501.666666666668,23735.166666666668,null,{"$f":"(BF14+ROUND((BG14-BF14)/3*faktor,0))/12","v":27954988.083333332},{"$f":"(BG14+ROUND((BH14-BG14)/3*faktor,0))/12","v":19348531.333333332},{"$f":"(BH14+ROUND((BI14-BH14)/3*faktor,0))/12","v":27934852.666666668},{"$f":"(BI14+ROUND((BJ14-BI14)/3*faktor,0))/12","v":19362905.666666668},null,9,169651,101478,271129,3143,5319,8461,10637,null,2532,4284,6815,8568,null,4047,6847,10891,13693,{"$f":"AR14/12","v":22931.333333333332},271129,{"$f":"ROUND($AA14+AL14,0)","v":275176},{"$f":"$AA14+AM14","v":277976},{"$f":"$AA14+AN14","v":282020},{"$f":"$AA14+AO14","v":284822},null,169651,101478.27250900002,271129,null,4047,6847,10891,13693,null,271129,275176,277976,282020,284822,null,9,140.91943866943868,143.02286902286903,144.47817047817048,146.58004158004158,148.03638253638255,null,9,211.379158004158,214.53430353430355,216.71725571725574,219.87006237006239,222.05457380457381,null,9,70.459719334719338,71.511434511434516,72.239085239085242,73.29002079002079,74.018191268191273]
[10,22753.666666666668,23099.25,23338.5,23683.916666666668,23923.25,null,28645347.666666668,19838741.25,28632128.5,null,10,22753.666666666668,23099.25,23338.5,23683.916666666668,23923.25,null,28645347.666666668,19838741.25,28632128.5,19846227.916666668,null,10,170849,102195,273044,3221,5451,8672,10903,null,2595,4391,6985,8782,null,4147,7018,11163,14035,null,273044,{"$f":"$AA15+AL15","v":277191},280062,284207,287079,null,170849,102194.86699100002,273044,null,4147,7018,11163,14035,null,273044,277191,280062,284207,287079,null,10,141.9147609147609,144.07016632016632,145.56237006237006,147.71673596673597,149.20945945945945,null,10,212.87214137214136,216.10524948024948,218.3435550935551,221.57510395010394,223.81418918918916,null,10,70.957380457380452,72.035083160083161,72.781185031185032,73.858367983367984,74.604729729729726]
[11,23186.916666666668,23541.083333333332,23786.333333333332,24140.5,24385.833333333332,null,29356686.916666668,20336127.083333332,29357286.333333332,null,11,23186.916666666668,23541.083333333332,23786.333333333332,24140.5,24385.833333333332,null,29356686.916666668,20336127.083333332,29357286.333333332,20343628.5,null,11,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y16+$Y$5)*regulering,0),ROUND(Y16*regulering,0))","v":104141},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,Y16:Z16),SUM(Y16:Z16))","v":278243},3301,5588,8889,11175,2659,2659,4501,7160,9002,null,4250,7193,11443,14387,null,278243,282493,285436,289686,292630,null,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW16+$Y$5)*regulering,0),ROUND(AW16*regulering,0))","v":104141},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,AW16:AX16),SUM(AW16:AX16))","v":278243},null,4250,7193,11443,14387,null,278243,282493,285436,289686,292630,null,11,144.61694386694387,146.82588357588358,148.35550935550935,150.56444906444906,152.09459459459458,null,11,216.92541580041581,220.23882536382536,222.53326403326403,225.84667359667361,228.14189189189187,null,11,72.308471933471935,73.41294178794179,74.177754677754677,75.282224532224532,76.047297297297291]
[12,23581.75,23944.833333333332,24196.083333333332,24559.25,24810.583333333332,null,30095595.75,20833474.833333332,30103112.083333332,null,12,23581.75,23944.833333333332,24196.083333333332,24559.25,24810.583333333332,null,30095595.75,20833474.833333332,30103112.083333332,20840991.25,null,12,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y17+$Y$5)*regulering,0),ROUND(Y17*regulering,0))","v":105914},282981,3384,5727,9112,11455,2726,2726,4613,7340,9227,null,4357,7372,11730,14746,null,282981,287338,290353,294711,297727,null,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW17+$Y$5)*regulering,0),ROUND(AW17*regulering,0))","v":105914},282981,null,4357,7372,11730,14746,null,282981,287338,290353,294711,297727,null,12,147.07952182952184,149.34407484407484,150.91112266112265,153.17619542619542,154.743762993763,null,12,220.61928274428277,224.01611226611226,226.36668399168397,229.76429313929313,232.11564449064451,null,12,73.539760914760919,74.67203742203742,75.455561330561324,76.58809771309771,77.3718814968815]
[13,23987.833333333332,24360.083333333332,24617.75,24990,25247.75,null,30855221.833333332,21365344.083333332,30855851.75,null,13,23987.833333333332,24360.083333333332,24617.75,24990,25247.75,null,30855221.833333332,21365344.083333332,30855851.75,21372876,null,13,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y18+$Y$5)*regulering,0),ROUND(Y18*regulering,0))","v":107738},287854,3470,5872,9342,11744,2795,2795,4730,7525,9460,null,4467,7559,12026,15119,null,287854,292321,295413,299880,302973,null,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW18+$Y$5)*regulering,0),ROUND(AW18*regulering,0))","v":107738},287854,null,4467,7559,12026,15119,null,287854,292321,295413,299880,302973,null,13,149.6122661122661,151.93399168399168,153.54106029106029,155.86278586278587,157.47037422037423,null,13,224.41839916839916,227.90098752598752,230.31159043659045,233.7941787941788,236.20556133056135,null,13,74.806133056133049,75.966995841995839,76.770530145530145,77.931392931392935,78.735187110187113]
[14,24405.083333333332,24786.666666666668,25050.75,25432.416666666668,25696.666666666668,null,31628663.083333332,21897224.666666668,31636210.75,null,14,24405.083333333332,24786.666666666668,25050.75,25432.416666666668,25696.666666666668,null,31628663.083333332,21897224.666666668,31636210.75,21911674.416666668,null,14,182214,109612,292861,3557,6019,9577,12039,2865,2865,4848,7714,9698,null,4579,7748,12328,15499,null,292861,297440,300609,305189,308360,null,182214,109612,292861,null,4579,7748,12328,15499,null,292861,297440,300609,305189,308360,null,14,152.21465696465697,154.59459459459458,156.241683991684,158.62214137214139,160.27027027027026,null,14,228.32198544698545,231.89189189189187,234.362525987526,237.93321205821206,240.40540540540539,null,14,76.107328482328484,77.297297297297291,78.120841995842,79.311070686070693,80.13513513513513]
[15,24817.166666666668,25208.333333333332,25479.333333333332,25870.333333333332,26141.25,null,32422805.166666668,22470512.333333332,32409663.333333332,null,15,24817.166666666668,25208.333333333332,25479.333333333332,25870.333333333332,26141.25,null,32422805.166666668,22470512.333333332,32409663.333333332,22464272.333333332,null,15,185308,111463,297806,3646,6172,9818,12343,2937,2937,4972,7908,9942,null,4694,7946,12638,15889,null,297806,302500,305752,310444,313695,null,185308,111463,297806,null,4694,7946,12638,15889,null,297806,302500,305752,310444,313695,null,15,154.78482328482329,157.22453222453223,158.9147609147609,161.35343035343035,163.04313929313929,null,15,232.17723492723493,235.83679833679832,238.37214137214136,242.03014553014555,244.56470893970894,null,15,77.392411642411645,78.612266112266113,79.457380457380452,80.676715176715177,81.521569646569645]
[16,25238.916666666668,25639.916666666668,25917.583333333332,26318.583333333332,26596.583333333332,null,33237662.916666668,23023103.916666668,33238341.583333332,null,16,25238.916666666668,25639.916666666668,25917.583333333332,26318.583333333332,26596.583333333332,null,33237662.916666668,23023103.916666668,33238341.583333332,23051390.583333332,null,16,188475,113357,302867,3738,6327,10065,12655,3011,3011,5096,8107,10194,null,4812,8144,12956,16292,null,302867,307679,311011,315823,319159,null,188475,113357,302867,null,4812,8144,12956,16292,null,302867,307679,311011,315823,319159,null,16,157.41528066528068,159.91632016632016,161.6481288981289,164.14916839916839,165.88305613305613,null,16,236.12292099792103,239.87448024948026,242.47219334719335,246.22375259875258,248.82458419958419,null,16,78.707640332640338,79.958160083160081,80.824064449064451,82.074584199584194,82.941528066528065]
[17,{"$f":"AQ22/12","v":25589.333333333332},26002.416666666668,26288.5,26701.75,26987.75,null,34238803.333333336,23720568.416666668,34253306.5,null,17,{"$f":"BF22/12","v":25589.333333333332},26002.416666666668,26288.5,26701.75,26987.75,null,34238803.333333336,23720568.416666668,34253306.5,23714365.75,null,17,191106,114931,307072,3851,6518,10370,13035,3102,3102,5250,8353,10500,null,4957,8390,13349,16781,null,307072,312029,315462,320421,323853,null,191106,114931,307072,null,4957,8390,13349,16781,null,307072,{"$f":"$BF22+BA22","v":312029},315462,320421,323853,null,17,{"$f":"AQ22/1924","v":159.60083160083161},162.17723492723493,163.96153846153845,166.53898128898129,168.32276507276507,null,17,239.40124740124742,243.26585239085239,245.94230769230768,249.80847193347194,252.48414760914761,null,17,{"$f":"AQ22/1924/2","v":79.800415800415806},81.088617463617467,81.980769230769226,83.269490644490645,84.161382536382533]
[18,26056.666666666668,26480.333333333332,26773.583333333332,27197.333333333332,27490.583333333332,null,35115824.666666664,24314618.333333332,35123443.583333336,null,18,26056.666666666668,26480.333333333332,26773.583333333332,27197.333333333332,27490.583333333332,null,35115824.666666664,24314618.333333332,35123443.583333336,24315335.333333332,null,18,194615,117030,312680,3949,6683,10633,13367,3181,3181,5383,8565,10767,null,5084,8603,13688,17207,null,312680,317764,321283,326368,329887,null,194615,117030,312680,null,5084,8603,13688,17207,null,312680,317764,321283,326368,329887,null,18,162.51559251559252,165.15800415800416,166.98700623700623,169.62993762993764,171.45893970893971,null,18,{"$f":"AQ23/1924*1.5","v":243.77338877338877},247.73700623700626,250.48050935550935,254.44490644490645,257.18840956340955,null,18,81.257796257796258,82.57900207900208,83.493503118503114,84.814968814968822,85.729469854469855]
[19,26406.5,26840.916666666668,27141.75,27576.25,27877.083333333332,null,36006532.5,24943060.916666668,36014169.75,null,19,26406.5,26840.916666666668,27141.75,27576.25,27877.083333333332,null,36006532.5,24943060.916666668,36014169.75,24943796.25,null,19,197242,118601,316878,4050,6854,10904,13708,3262,3262,5521,8783,11042,null,5213,8823,14037,17647,null,316878,322091,325701,330915,334525,null,197242,118601,316878,null,5213,8823,14037,17647,null,316878,322091,325701,330915,334525,null,19,164.69750519750519,167.40696465696465,169.28326403326403,171.99324324324326,173.86954261954261,null,19,247.04625779625781,251.11044698544697,253.92489604989606,257.9898648648649,260.80431392931393,null,19,82.348752598752597,83.703482328482323,84.641632016632016,85.996621621621628,86.934771309771307]
[20,26718.833333333332,27164.333333333332,27472.75,27918.416666666668,28226.666666666668,null,36924810.833333336,25571466.333333332,36939368.75,null,20,26718.833333333332,27164.333333333332,27472.75,27918.416666666668,28226.666666666668,null,36924810.833333336,25571466.333333332,36939368.75,25558416.416666668,null,20,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y25+$AC$5)*regulering,0),ROUND(Y25*regulering,0))","v":120004},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y25:Z25),SUM(Y25:Z25))","v":320626},4153,7028,11182,14056,3345,3345,5661,9007,11322,null,5346,9047,14395,18094,null,320626,325972,329673,335021,338720,null,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW25+$AC$5)*regulering,0),ROUND(AW25*regulering,0))","v":120004},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW25:AX25),SUM(AW25:AX25))","v":320626},null,5346,9047,14395,18094,null,320626,325972,329673,335021,338720,null,20,166.64553014553016,169.42411642411642,171.3477130977131,174.12733887733887,176.04989604989606,null,20,249.96829521829522,254.13617463617464,257.02156964656967,261.19100831600832,264.07484407484412,null,20,83.32276507276508,84.71205821205821,85.673856548856548,87.063669438669436,88.024948024948031]
[21,27160.583333333332,27617.5,27933.833333333332,28390.75,28707.083333333332,null,37870826.583333336,26227609.5,37871599.833333336,null,21,27160.583333333332,27617.5,27933.833333333332,28390.75,28707.083333333332,null,37870826.583333336,26227609.5,37871599.833333336,26228382.75,null,21,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y26+$AC$5)*regulering,0),ROUND(Y26*regulering,0))","v":121988},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y26:Z26),SUM(Y26:Z26))","v":325927},4259,7208,11467,14416,3431,3431,5806,9237,11612,null,{"$f":"ROUND(VLOOKUP($X26,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":5483},9279,14762,18558,null,325927,331410,335206,340689,344485,null,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW26+$AC$5)*regulering,0),ROUND(AW26*regulering,0))","v":121988},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW26:AX26),SUM(AW26:AX26))","v":325927},null,5483,9279,14762,18558,null,325927,331410,335206,340689,344485,null,21,169.40072765072765,172.25051975051974,174.22349272349271,177.07328482328484,179.04625779625781,null,21,254.10109147609148,258.37577962577961,261.3352390852391,265.60992723492723,268.56938669438671,null,21,84.700363825363823,86.125259875259871,87.111746361746356,88.536642411642418,89.523128898128903]
[22,27483.25,27940.166666666668,28256.5,28713.416666666668,29029.75,null,37871149.25,26227932.166666668,37871922.5,null,22,27483.25,27940.166666666668,28256.5,28713.416666666668,29029.75,null,37871149.25,26227932.166666668,37871922.5,26228705.416666668,null,22,206362,123437,329799,4259,7208,11467,14416,null,3431,5806,9237,11612,null,5483,9279,14762,18558,null,329799,335282,339078,344561,348357,null,206362,123437.28755800003,329799,null,5483,9279,14762,18558,null,329799,335282,339078,344561,348357,null,22,171.41320166320168,174.26299376299377,176.23596673596674,179.08575883575884,181.05873180873181,null,22,257.11980249480251,261.39449064449065,264.35395010395013,268.62863825363826,271.58809771309768,null,22,85.706600831600838,87.131496881496886,88.117983367983371,89.542879417879419,90.529365904365903]
[23,27921.583333333332,28366.166666666668,28673.666666666668,29118.083333333332,29425.75,null,36850091.583333336,25496746.166666668,36837039.666666664,null,23,27921.583333333332,28366.166666666668,28673.666666666668,29118.083333333332,29425.75,null,36850091.583333336,25496746.166666668,36837039.666666664,25511302.083333332,null,23,209653,125406,335059,4144,7010,11153,14021,null,3338,5647,8984,11294,null,5335,9025,14358,18050,null,335059,340394,344084,349417,353109,null,209653,125405.82882700002,335059,null,5335,9025,14358,18050,null,335059,340394,344084,349417,353109,null,23,174.14708939708939,176.91995841995842,178.83783783783784,181.60966735966736,183.52858627858629,null,23,261.22063409563407,265.37993762993761,268.25675675675677,272.41450103950103,275.29287941787942,null,23,87.073544698544694,88.45997920997921,89.418918918918919,90.804833679833678,91.764293139293144]
[24,28373.833333333332,28805.583333333332,29104.583333333332,29536.333333333332,29835.25,null,35787635.833333336,24793181.583333332,35788366.583333336,null,24,28373.833333333332,28805.583333333332,29104.583333333332,29536.333333333332,29835.25,null,35787635.833333336,24793181.583333332,35788366.583333336,24787010.333333332,null,24,213049,127437,340486,4025,6812,10837,13623,null,3242,5487,8729,10973,null,5181,8769,13950,17537,null,340486,345667,349255,354436,358023,null,213049,127437.17679100002,340486,null,5181,8769,13950,17537,null,340486,345667,349255,354436,358023,null,24,176.96777546777548,179.6606029106029,181.52546777546777,184.21829521829522,186.08264033264032,null,24,265.45166320166322,269.49090436590438,272.28820166320168,276.32744282744284,279.12396049896051,null,24,88.483887733887741,89.830301455301452,90.762733887733887,92.109147609147612,93.041320166320162]
[25,28835.583333333332,29253.916666666668,29543.416666666668,29961.916666666668,{"$f":"AU30/12","v":30251.416666666668},null,34676875.583333336,24006801.916666668,34691387.416666664,null,25,28835.583333333332,29253.916666666668,29543.416666666668,29961.916666666668,30251.416666666668,null,34676875.583333336,24006801.916666668,34691387.416666664,24007509.916666668,null,25,216516,129511,346027,3899,6598,10499,13198,null,3141,5315,8457,10631,null,5020,8494,13516,16990,null,346027,351047,354521,359543,363017,null,216516,129510.99404400002,346027,null,5020,8494,13516,16990,null,346027,351047,354521,359543,363017,null,25,179.8477130977131,182.45686070686071,184.262474012474,186.87266112266113,188.67827442827442,null,25,269.77156964656967,273.68529106029109,276.39371101871097,280.30899168399168,283.01741164241162,null,25,89.923856548856548,91.228430353430355,92.131237006237001,93.436330561330564,94.33913721413721]
[26,29308,29712.083333333332,29991.583333333332,30395.416666666668,30675.083333333332,null,33497106,23179020.083333332,33477083.583333332,null,26,29308,29712.083333333332,29991.583333333332,30395.416666666668,30675.083333333332,null,33497106,23179020.083333332,33477083.583333332,23193507.416666668,null,26,220063,131633,351696,3766,6372,10137,12743,null,3034,5133,8165,10265,null,4849,8203,13049,16405,null,351696,356545,359899,364745,368101,null,220063,131632.66401700003,351696,null,4849,8203,13049,16405,null,351696,356545,359899,364745,368101,null,26,182.7941787941788,185.31444906444906,187.05769230769232,189.57640332640332,191.32068607068607,null,26,274.19126819126819,277.97167359667361,280.58653846153845,284.36460498960497,286.9810291060291,null,26,91.397089397089402,92.657224532224532,93.52884615384616,94.788201663201662,95.660343035343033]
[27,29791.166666666668,30179.666666666668,30448.416666666668,30836.916666666668,31105.75,null,32206915.166666668,22289129.666666668,32207572.416666668,null,27,29791.166666666668,30179.666666666668,30448.416666666668,30836.916666666668,31105.75,null,32206915.166666668,22289129.666666668,32207572.416666668,22296688.916666668,null,27,223691,133803,357494,3621,6127,9748,12254,null,2917,4935,7852,9871,null,4662,7887,12549,15775,null,357494,362156,365381,370043,373269,null,223691,133802.78486900002,357494,null,4662,7887,12549,15775,null,357494,362156,365381,370043,373269,null,27,185.80769230769232,188.23076923076923,189.90696465696465,192.33004158004158,194.00675675675674,null,27,278.71153846153845,282.34615384615381,284.86044698544697,288.49506237006239,291.0101351351351,null,27,92.90384615384616,94.115384615384613,94.953482328482323,96.16502079002079,97.003378378378372]
[28,30285,30657,30914.416666666668,31286.416666666668,31543.666666666668,null,30840813,21350935,30841442.416666668,null,28,30285,30657,30914.416666666668,31286.416666666668,31543.666666666668,null,30840813,21350935,30841442.416666668,21337760.416666668,null,28,227399,136021,363420,3467,5867,9334,11733,null,2793,4726,7519,9451,null,4464,7553,12017,15104,null,363420,367884,370973,375437,378524,null,227399,136020.75844100001,363420,null,4464,7553,12017,15104,null,363420,367884,370973,375437,378524,null,28,188.8877338877339,191.2079002079002,192.81340956340955,195.13357588357587,196.73804573804574,null,28,283.33160083160084,286.81185031185032,289.22011434511433,292.70036382536381,295.10706860706864,null,28,94.443866943866951,95.603950103950098,96.406704781704775,97.566787941787936,98.369022869022871]
[29,30790,31144.416666666668,31389.583333333332,31743.833333333332,31989.166666666668,null,29384996,20336828.416666668,29371791.583333332,null,29,30790,31144.416666666668,31389.583333333332,31743.833333333332,31989.166666666668,null,29384996,20336828.416666668,29371791.583333332,20351231.833333332,null,29,231191,138289,369480,3303,5589,8891,11178,null,2661,4502,7162,9004,null,4253,7195,11446,14390,null,369480,373733,376675,380926,383870,null,231191,138288.97736900003,369480,null,4253,7195,11446,14390,null,369480,373733,376675,380926,383870,null,29,192.03742203742203,194.247920997921,195.77702702702703,197.98648648648648,199.51663201663203,null,29,288.05613305613304,291.37188149688149,293.66554054054052,296.97972972972974,299.27494802494806,null,29,96.018711018711016,97.1239604989605,97.888513513513516,98.993243243243242,99.758316008316015]
[30,31305.916666666668,31641.416666666668,31873.833333333332,32209.166666666668,32441.416666666668,null,27818757.916666668,19281319.416666668,27805521.833333332,null,30,31305.916666666668,31641.416666666668,31873.833333333332,32209.166666666668,32441.416666666668,null,27818757.916666668,19281319.416666668,27805521.833333332,19268083.166666668,null,30,235065,140606,375671,3127,5293,8420,10585,null,2519,4264,6782,8526,null,4026,6815,10839,13626,null,375671,379697,382486,386510,389297,null,235065,140606.24533500001,375671,null,4026,6815,10839,13626,null,375671,379697,382486,386510,389297,null,30,195.25519750519751,197.3477130977131,198.79729729729729,200.88877338877339,202.3373180873181,null,30,292.88279625779626,296.02156964656967,298.19594594594594,301.33316008316007,303.50597713097716,null,30,97.627598752598757,98.673856548856548,99.398648648648646,100.44438669438669,101.16865904365905]
[31,31833.583333333332,32149.25,32367.666666666668,32683.25,32901.666666666664,null,26176609.583333332,18122291.25,26170241.666666668,null,31,31833.583333333332,32149.25,32367.666666666668,32683.25,32901.666666666664,null,26176609.583333332,18122291.25,26170241.666666668,18122825.25,null,31,239027,142976,382003,2942,4978,7920,9956,null,2370,4010,6380,8020,null,3788,6409,10196,12817,null,382003,385791,388412,392199,394820,null,239027,142976.15129300003,382003,null,3788,6409,10196,12817,null,382003,385791,388412,392199,394820,null,31,198.54625779625781,200.51507276507277,201.87733887733887,203.8456340956341,205.2079002079002,null,31,297.81938669438671,300.77260914760916,302.81600831600832,305.76845114345116,307.81185031185032,null,31,99.273128898128903,100.25753638253639,100.93866943866944,101.92281704781705,102.6039501039501]
[32,32373,32667.333333333332,32871,33165.416666666664,33369.166666666664,null,24410237,16901155.333333332,24417637,null,32,32373,32667.333333333332,32871,33165.416666666664,33369.166666666664,null,24410237,16901155.333333332,24417637,16908555.416666668,null,32,243077,145399,388476,2743,4642,7387,9286,null,2210,3739,5950,7480,null,3532,5976,9509,11954,null,388476,392008,394452,397985,400430,null,243077,145398.69524300002,388476,null,3532,5976,9509,11954,null,388476,392008,394452,397985,400430,null,32,201.9106029106029,203.74636174636174,205.01663201663203,206.85291060291061,208.12370062370061,null,32,302.86590436590438,305.61954261954259,307.52494802494806,310.27936590436593,312.18555093555091,null,32,100.95530145530145,101.87318087318087,102.50831600831602,103.42645530145531,104.06185031185031]
[33,32924.083333333336,33195.916666666664,33384.083333333336,33655.916666666664,33843.916666666664,null,22547248.083333332,15617911.916666666,22547708.083333332,null,33,32924.083333333336,33195.916666666664,33384.083333333336,33655.916666666664,33843.916666666664,null,22547248.083333332,15617911.916666666,22547708.083333332,15604567.916666666,null,33,247215,{"$f":"ROUND(Y38*regulering,0)","v":147874},395089,2534,4288,6822,8575,null,2041,3454,5495,6907,null,3262,5520,8782,11038,null,395089,398351,400609,403871,406127,null,247215,{"$f":"AW38*regulering","v":147873.87718500002},395089,null,{"$f":"ROUND(AL38*udbygningspct,0)","v":3262},{"$f":"ROUND(AM38*udbygningspct,0)","v":5520},{"$f":"ROUND(AN38*udbygningspct,0)","v":8782},{"$f":"ROUND(AO38*udbygningspct,0)","v":11038},null,395089,398351,400609,403871,406127,null,33,205.3477130977131,207.04313929313929,208.21673596673597,209.91216216216216,211.08471933471932,null,33,308.02156964656967,310.56470893970891,312.32510395010394,314.86824324324323,316.62707900207897,null,33,102.67385654885655,103.52156964656965,104.10836798336798,104.95608108108108,105.54235966735966]
[34,33487.916666666664,33735.916666666664,33907.416666666664,34155.416666666664,34327.083333333336,null,20573839.916666668,14238051.916666666,20574259.416666668,null,34,33487.916666666664,33735.916666666664,33907.416666666664,34155.416666666664,34327.083333333336,null,20573839.916666668,14238051.916666666,20574259.416666668,14252275.416666666,null,34,251449,150406,401855,2311,3911,6222,7823,null,1862,3150,5012,6301,null,2976,5034,8010,10070,null,401855,404831,406889,409865,411925,null,251449,150406.48239100003,401855,null,2976,5034,8010,10070,null,401855,404831,406889,409865,411925,null,34,208.86434511434513,210.41112266112265,211.48076923076923,213.02754677754677,214.09823284823284,null,34,313.29651767151768,315.616683991684,317.22115384615381,319.54132016632013,321.14734927234929,null,34,104.43217255717256,105.20556133056132,105.74038461538461,106.51377338877339,107.04911642411642]
[35,34063.666666666664,34286.333333333336,34440.416666666664,34663,34817.166666666664,null,18476207.666666668,12796084.333333334,18469682.416666668,null,35,34063.666666666664,34286.333333333336,34440.416666666664,34663,34817.166666666664,null,18476207.666666668,12796084.333333334,18469682.416666668,12803363,null,35,255772,152992,408764,2076,3512,5586,7024,null,1672,2829,4500,5658,null,2672,4521,7192,9042,null,408764,411436,413285,415956,417806,null,255772,152992.32374800002,408764,null,2672,4521,7192,9042,null,408764,411436,413285,415956,417806,null,35,212.45530145530145,213.84407484407484,214.80509355509355,216.19334719334719,217.15488565488565,null,35,318.68295218295219,320.76611226611226,322.20764033264032,324.29002079002078,325.73232848232846,null,35,106.22765072765073,106.92203742203742,107.40254677754677,108.0966735966736,108.57744282744282]
[36,34652.583333333336,34848.5,34983.916666666664,35179.75,35315.25,null,16261254.583333334,11250598.5,16254683.916666666,null,36,34652.583333333336,34848.5,34983.916666666664,35179.75,35315.25,null,16261254.583333334,11250598.5,16254683.916666666,11257831.75,null,36,260194,155637,415831,1826,3089,4914,6177,null,1471,2488,3958,4976,null,2351,3976,6326,7952,null,415831,418182,419807,422157,423783,null,260194,155637.38284600002,415831,null,2351,3976,6326,7952,null,415831,418182,419807,422157,423783,null,36,216.12837837837839,217.35031185031184,218.19490644490645,219.41632016632016,220.26143451143452,null,36,324.19256756756761,326.02546777546775,327.29235966735968,329.12448024948026,330.39215176715174,null,36,108.06418918918919,108.67515592515592,109.09745322245323,109.70816008316008,110.13071725571726]
[37,35254.333333333336,35421.75,35537.75,35705.166666666664,35821,null,13901372.333333334,9643005.75,13901655.75,null,37,35254.333333333336,35421.75,35537.75,35705.166666666664,35821,null,13901372.333333334,9643005.75,13901655.75,9629485.166666666,null,37,264712,158340,423052,1560,2642,4202,5282,null,1257,2128,3385,4255,null,2009,3401,5410,6800,null,423052,425061,426453,428462,429852,null,264712,158339.86520800003,423052,null,2009,3401,5410,6800,null,423052,425061,426453,428462,429852,null,37,219.88149688149687,220.92567567567568,221.64916839916839,222.69334719334719,223.41580041580042,null,37,329.82224532224529,331.38851351351354,332.47375259875258,334.04002079002078,335.12370062370064,null,37,109.94074844074844,110.46283783783784,110.82458419958419,111.3466735966736,111.70790020790021]
[38,35893.083333333336,36033.166666666664,36130.25,36270.416666666664,36367.583333333336,null,11638155.083333334,8076863.166666667,11645294.25,null,38,35893.083333333336,36033.166666666664,36130.25,36270.416666666664,36367.583333333336,null,11638155.083333334,8076863.166666667,11645294.25,8084002.416666667,null,38,269508,161209,430717,1306,2211,3517,4423,null,1052,1781,2833,3563,null,1681,2846,4528,5694,null,430717,432398,433563,435245,436411,null,269508,161208.63577200004,430717,null,1681,2846,4528,5694,null,430717,432398,433563,435245,436411,null,38,223.86538461538461,224.73908523908523,225.34459459459458,226.21881496881497,226.82484407484407,null,38,335.79807692307691,337.10862785862787,338.01689189189187,339.32822245322245,340.23726611226607,null,38,111.93269230769231,112.36954261954261,112.67229729729729,113.10940748440748,113.41242203742203]
[39,36534.333333333336,36642.25,36716.916666666664,36824.833333333336,36899.666666666664,null,8974624.333333334,6220834.25,8974806.916666666,null,39,36534.333333333336,36642.25,36716.916666666664,36824.833333333336,36899.666666666664,null,8974624.333333334,6220834.25,8974806.916666666,6234820.833333333,null,39,274323,164089,438412,1006,1702,2708,3405,null,810,1371,2181,2743,null,1295,2191,3486,4384,null,438412,439707,440603,441898,442796,null,274323,164088.77135700002,438412,null,1295,2191,3486,4384,null,438412,439707,440603,441898,442796,null,39,227.86486486486487,228.53794178794178,229.00363825363826,229.67671517671516,230.14345114345113,null,39,341.79729729729729,342.80691268191265,343.50545738045741,344.51507276507277,345.21517671517671,null,39,113.93243243243244,114.26897089397089,114.50181912681913,114.83835758835758,115.07172557172557]
[40,37190.083333333336,37263.833333333336,37315,37388.916666666664,37440.083333333336,null,6145460.083333333,4275091.833333333,6159389,null,40,37190.083333333336,37263.833333333336,37315,37388.916666666664,37440.083333333336,null,6145460.083333333,4275091.833333333,6159389,4275216.916666667,null,40,279247,167034,446281,688,1165,1853,2330,null,554,938,1493,1877,null,885,1499,2386,3000,null,446281,447166,447780,448667,449281,null,279247,167034.10627300004,446281,null,885,1499,2386,3000,null,{"$f":"AY45","v":446281},447166,447780,448667,449281,null,40,231.95478170478171,232.4147609147609,232.73388773388774,233.19490644490645,233.51403326403326,null,40,347.93217255717258,348.62214137214136,349.10083160083161,349.79235966735968,350.27104989604987,null,40,115.97739085239085,116.20738045738045,116.36694386694387,116.59745322245323,116.75701663201663]
[41,37860.083333333336,37897.916666666664,37924.25,37962,37988.333333333336,null,3171368.0833333335,2218929.9166666665,3164530.25,null,41,37860.083333333336,37897.916666666664,37924.25,37962,37988.333333333336,null,3171368.0833333335,2218929.9166666665,3164530.25,2218994,null,41,284278,170043,454321,353,598,950,1195,null,284,482,765,963,null,{"$f":"ROUND(VLOOKUP($X46,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":454},770,1223,1539,null,454321,454775,455091,455544,455860,null,284278,170043.44420200004,454321,null,454,770,1223,1539,null,{"$f":"AY46","v":454321},454775,455091,455544,455860,null,41,236.13357588357587,236.36954261954261,236.53378378378378,236.76923076923077,236.93347193347194,null,41,354.20036382536381,354.55431392931393,354.80067567567568,355.15384615384619,355.40020790020787,null,41,118.06678794178794,118.18477130977131,118.26689189189189,118.38461538461539,118.46673596673597]
[42,38544.666666666664,38544.666666666664,38544.666666666664,38544.666666666664,38544.666666666664,null,38544.666666666664,38544.666666666664,38544.666666666664,null,42,38544.666666666664,38544.666666666664,38544.666666666664,38544.666666666664,38544.666666666664,null,38544.666666666664,38544.666666666664,38544.666666666664,38544.666666666664,null,42,289418,173118,462536,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,462536,462536,462536,462536,462536,null,289418,173117.98146200003,462536,null,0,0,0,0,null,462536,462536,462536,462536,462536,null,42,240.40332640332642,240.40332640332642,240.40332640332642,240.40332640332642,240.40332640332642,null,42,360.60498960498961,360.60498960498961,360.60498960498961,360.60498960498961,360.60498960498961,null,42,120.20166320166321,120.20166320166321,120.20166320166321,120.20166320166321,120.20166320166321]
[43,39401.25,39401.25,39401.25,39401.25,39401.25,null,39401.25,39401.25,39401.25,null,43,39401.25,39401.25,39401.25,39401.25,39401.25,null,39401.25,39401.25,39401.25,39401.25,null,43,295850,176965,472815,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,472815,472815,472815,472815,472815,null,295850,176965.34015000003,472815,null,0,0,0,0,null,472815,472815,472815,472815,472815,null,43,245.745841995842,245.745841995842,245.745841995842,245.745841995842,245.745841995842,null,43,368.61876299376297,368.61876299376297,368.61876299376297,368.61876299376297,368.61876299376297,null,43,122.872920997921,122.872920997921,122.872920997921,122.872920997921,122.872920997921]
[44,40281.583333333336,40281.583333333336,40281.583333333336,40281.583333333336,40281.583333333336,null,40281.583333333336,40281.583333333336,40281.583333333336,null,44,40281.583333333336,40281.583333333336,40281.583333333336,40281.583333333336,40281.583333333336,null,40281.583333333336,40281.583333333336,40281.583333333336,40281.583333333336,null,44,302460,180919,483379,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,483379,483379,483379,483379,483379,null,302460,180919.17114000002,483379,null,0,0,0,0,null,483379,483379,483379,483379,483379,null,44,251.23648648648648,251.23648648648648,251.23648648648648,251.23648648648648,251.23648648648648,null,44,376.85472972972974,376.85472972972974,376.85472972972974,376.85472972972974,376.85472972972974,null,44,125.61824324324324,125.61824324324324,125.61824324324324,125.61824324324324,125.61824324324324]
[45,41186,41186,41186,41186,41186,null,41186,41186,41186,null,45,41186,41186,41186,41186,41186,null,41186,41186,41186,41186,null,45,309251,184981,494232,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,494232,494232,494232,494232,494232,null,309251,184981.26890900003,494232,null,0,0,0,0,null,494232,494232,494232,494232,494232,null,45,256.8773388773389,256.8773388773389,256.8773388773389,256.8773388773389,256.8773388773389,null,45,385.31600831600838,385.31600831600838,385.31600831600838,385.31600831600838,385.31600831600838,null,45,128.43866943866945,128.43866943866945,128.43866943866945,128.43866943866945,128.43866943866945]
[46,42115.333333333336,42115.333333333336,42115.333333333336,42115.333333333336,42115.333333333336,null,42115.333333333336,42115.333333333336,42115.333333333336,null,46,42115.333333333336,42115.333333333336,42115.333333333336,42115.333333333336,42115.333333333336,null,42115.333333333336,42115.333333333336,42115.333333333336,42115.333333333336,null,46,316229,189155,505384,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,505384,505384,505384,505384,505384,null,316229,189155.22241100002,505384,null,0,0,0,0,null,505384,505384,505384,505384,505384,null,46,262.67359667359665,262.67359667359665,262.67359667359665,262.67359667359665,262.67359667359665,null,46,394.01039501039497,394.01039501039497,394.01039501039497,394.01039501039497,394.01039501039497,null,46,131.33679833679832,131.33679833679832,131.33679833679832,131.33679833679832,131.33679833679832]
[47,42865,42865,42865,42865,42865,null,42865,42865,42865,null,47,42865,42865,42865,42865,42865,null,42865,42865,42865,42865,null,47,321858,192522,514380,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,514380,514380,514380,514380,514380,null,321858,192522.25942200003,514380,null,0,0,0,0,null,514380,514380,514380,514380,514380,null,47,267.34927234927233,267.34927234927233,267.34927234927233,267.34927234927233,267.34927234927233,null,47,401.02390852390852,401.02390852390852,401.02390852390852,401.02390852390852,401.02390852390852,null,47,133.67463617463616,133.67463617463616,133.67463617463616,133.67463617463616,133.67463617463616]
[48,44835.416666666664,44835.416666666664,44835.416666666664,44835.416666666664,44835.416666666664,null,44835.416666666664,44835.416666666664,44835.416666666664,null,48,44835.416666666664,44835.416666666664,44835.416666666664,44835.416666666664,44835.416666666664,null,44835.416666666664,44835.416666666664,44835.416666666664,44835.416666666664,null,48,336653,201372,538025,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,538025,538025,538025,538025,538025,null,336653,201372.02182700005,538025,null,0,0,0,0,null,538025,538025,538025,538025,538025,null,48,279.63877338877342,279.63877338877342,279.63877338877342,279.63877338877342,279.63877338877342,null,48,419.45816008316012,419.45816008316012,419.45816008316012,419.45816008316012,419.45816008316012,null,48,139.81938669438671,139.81938669438671,139.81938669438671,139.81938669438671,139.81938669438671]
[49,47844.333333333336,47844.333333333336,47844.333333333336,47844.333333333336,47844.333333333336,null,47844.333333333336,47844.333333333336,47844.333333333336,null,49,{"$f":"BF54/12","v":47844.333333333336},47844.333333333336,47844.333333333336,47844.333333333336,47844.333333333336,null,47844.333333333336,47844.333333333336,47844.333333333336,47844.333333333336,null,49,359246,214886,574132,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,574132,574132,574132,574132,574132,null,359246,214886.22811400003,574132,null,0,0,0,0,null,574132,574132,574132,574132,574132,null,49,298.40540540540542,298.40540540540542,298.40540540540542,298.40540540540542,298.40540540540542,null,49,447.60810810810813,447.60810810810813,447.60810810810813,447.60810810810813,447.60810810810813,null,49,149.20270270270271,149.20270270270271,149.20270270270271,149.20270270270271,149.20270270270271]
[50,51184.25,51184.25,51184.25,51184.25,51184.25,null,51184.25,51184.25,51184.25,null,50,{"$f":"BF55/12","v":52391.5},52391.5,52391.5,52391.5,52391.5,null,52391.5,52391.5,52391.5,52391.5,null,50,384324,229887,614211,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,614211,614211,614211,614211,614211,null,393389,235309.17085100003,628698,null,0,0,0,0,null,628698,628698,628698,628698,628698,null,50,319.23648648648651,319.23648648648651,319.23648648648651,319.23648648648651,319.23648648648651,null,50,478.8547297297298,478.8547297297298,478.8547297297298,478.8547297297298,478.8547297297298,null,50,159.61824324324326,159.61824324324326,159.61824324324326,159.61824324324326,159.61824324324326]
[51,56536.75,56536.75,56536.75,56536.75,56536.75,null,56536.75,56536.75,56536.75,null,51,58058.583333333336,58058.583333333336,58058.583333333336,58058.583333333336,58058.583333333336,null,58058.583333333336,58058.583333333336,58058.583333333336,58058.583333333336,null,51,424514,253927,678441,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,678441,678441,678441,678441,678441,null,435941,260762.03261900003,696703,null,0,0,0,0,null,696703,696703,696703,696703,696703,null,51,352.62006237006239,352.62006237006239,352.62006237006239,352.62006237006239,352.62006237006239,null,51,528.93009355509355,528.93009355509355,528.93009355509355,528.93009355509355,528.93009355509355,null,51,176.31003118503119,176.31003118503119,176.31003118503119,176.31003118503119,176.31003118503119]
[52,64331.75,64331.75,64331.75,64331.75,64331.75,null,64331.75,64331.75,64331.75,null,52,66122.666666666672,66122.666666666672,66122.666666666672,66122.666666666672,66122.666666666672,null,66122.666666666672,66122.666666666672,66122.666666666672,66122.666666666672,null,52,483044,288937,771981,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,771981,771981,771981,771981,771981,null,496491,296980.56006900006,793472,null,0,0,0,0,null,793472,793472,793472,793472,793472,null,52,401.237525987526,401.237525987526,401.237525987526,401.237525987526,401.237525987526,null,52,601.85628898128903,601.85628898128903,601.85628898128903,601.85628898128903,601.85628898128903,null,52,200.618762993763,200.618762993763,200.618762993763,200.618762993763,200.618762993763]
[53,70633.833333333328,70633.833333333328,70633.833333333328,70633.833333333328,70633.833333333328,null,70633.833333333328,70633.833333333328,70633.833333333328,null,53,73605.5,73605.5,73605.5,73605.5,73605.5,null,73605.5,73605.5,73605.5,73605.5,null,53,530364,317242,847606,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,847606,847606,847606,847606,847606,null,552677,330588.72164300008,883266,null,0,0,0,0,null,883266,883266,883266,883266,883266,null,53,440.54365904365903,440.54365904365903,440.54365904365903,440.54365904365903,440.54365904365903,null,53,660.81548856548852,660.81548856548852,660.81548856548852,660.81548856548852,660.81548856548852,null,53,220.27182952182952,220.27182952182952,220.27182952182952,220.27182952182952,220.27182952182952]
[54,79035.5,79035.5,79035.5,79035.5,79035.5,null,79035.5,79035.5,79035.5,null,54,82931.666666666672,82931.666666666672,82931.666666666672,82931.666666666672,82931.666666666672,null,82931.666666666672,82931.666666666672,82931.666666666672,82931.666666666672,null,54,593449,354977,948426,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,948426,948426,948426,948426,948426,null,622704,372476.00193600007,995180,null,0,0,0,0,null,995180,995180,995180,995180,995180,null,54,492.94490644490645,492.94490644490645,492.94490644490645,492.94490644490645,492.94490644490645,null,54,739.41735966735973,739.41735966735973,739.41735966735973,739.41735966735973,739.41735966735973,null,54,246.47245322245323,246.47245322245323,246.47245322245323,246.47245322245323,246.47245322245323]
[55,89134.416666666672,89134.416666666672,89134.416666666672,89134.416666666672,89134.416666666672,null,89134.416666666672,89134.416666666672,89134.416666666672,null,55,93030.583333333328,93030.583333333328,93030.583333333328,93030.583333333328,93030.583333333328,null,93030.583333333328,93030.583333333328,93030.583333333328,93030.583333333328,null,55,669278,400335,1069613,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,1069613,1069613,1069613,1069613,1069613,null,698533,417833.80074700009,1116367,null,0,0,0,0,null,1116367,1116367,1116367,1116367,1116367,null,55,555.93191268191265,555.93191268191265,555.93191268191265,555.93191268191265,555.93191268191265,null,55,833.89786902286892,833.89786902286892,833.89786902286892,833.89786902286892,833.89786902286892,null,55,277.96595634095632,277.96595634095632,277.96595634095632,277.96595634095632,277.96595634095632]
[56,100458.83333333333,100458.83333333333,100458.83333333333,100458.83333333333,100458.83333333333,null,100458.83333333333,100458.83333333333,100458.83333333333,null,56,104355.25,104355.25,104355.25,104355.25,104355.25,null,104355.25,104355.25,104355.25,104355.25,null,56,754309,451197,1205506,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,1205506,1205506,1205506,1205506,1205506,null,783566,468697.05499400006,1252263,null,0,0,0,0,null,1252263,1252263,1252263,1252263,1252263,null,56,626.56237006237006,626.56237006237006,626.56237006237006,626.56237006237006,626.56237006237006,null,56,939.8435550935551,939.8435550935551,939.8435550935551,939.8435550935551,939.8435550935551,null,56,313.28118503118503,313.28118503118503,313.28118503118503,313.28118503118503,313.28118503118503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Y62*valgt_regulering,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",4131.67,4204.9799999999996,4265.26,4358.1099999999997,4420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",4229.54,4303.8900000000003,4365.01,4459.17,4521.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Forside","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,3,14,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Lønniveau:","2024-10-01"]
[]
[]
[]
[null,null,null,"Hvad betyder det for lønnen, hvis man ændrer på lønsammensætning eller timetal ?"]

{"sheet":"Omregner","index":4,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Valgt lønniveau:",null,{"$f":"Forside!K11","v":"2024-10-01"},null,"Timetal:",37]
[]
[null,"1) Grundbeløb pr. 31-3-2000 omregnet til nutidskr. "]
[null,null,"Årligt grundbeløb:",null,8489]
[]
[null,null,null,null,"år","måned"]
[null,null,"Aktuelt beløb",null,{"$f":"ROUND(((kr_omregnes*valgt_regulering)/37*I11),0)","v":13567},{"$f":"E17/12","v":1130.5833333333333}]
[]
[]
[null,"2) Beløb der skal omregnes til '31-3-2000-niveau'"]
[null,null,"Månedligt beløb",null,1485.6]
[]
[null,null,null,null,"år","måned"]
[null,null,"Grundbeløb pr. 31-3-2000",null,{"$f":"ROUND(E21*12/valgt_regulering,0)/I11*37","v":11155.000000000002},{"$f":"E24/12","v":929.58333333333348}]

{"sheet":"Omregningstabel ","index":5,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,1.362716,1.3824959999999999,1.3980790000000001,1.018559,1.040662,1.0511569999999999,1.061566,1.0834220000000001,1.0886800000000001,1.0926750000000001,1.109523,1.1200380000000001,1.1244540000000001]
[]
[]
[]
[]
[]
[null,"Indtast beløb:",1000]
[]
[]
[null,null,"1/10 '84"]
[null,null,{"$f":"Beløb","v":1000},"1/4 '98"]
[null,"1/4-98",{"$f":"Beløb*_1_4_1998","v":1362.7160000000001},{"$f":"Beløb","v":1000},"1/10 '98"]
[null,"1/10-98",{"$f":"Beløb*_1_10_1998","v":1382.4959999999999},{"$f":"Beløb/_1_4_1998*_1_10_1998","v":1014.515130078461},{"$f":"Beløb","v":1000},"1/4 '99"]
[null,"1/4-99",{"$f":"Beløb*_1_4_1999","v":1398.0790000000002},{"$f":"Beløb/_1_4_1998*_1_4_1999","v":1025.9503814441161},{"$f":"Beløb/_1_10_1998*_1_4_1999","v":1011.2716420156008},{"$f":"Beløb","v":1000}]
[null,"Grundbeløb pr. 31/3-00",{"$f":"ROUND(C14,-2)","v":1400},{"$f":"ROUND(D14,-2)","v":1000},{"$f":"ROUND(E14,-2)","v":1000},{"$f":"ROUND(F14,-2)","v":1000},"1/4 '00"]
[null,"1/4-00",{"$f":"Nyt_beløb_1*_1_4_2000","v":1425.9826},{"$f":"Nyt_beløb_2*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_3*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_4*_1_4_2000","v":1018.559},{"$f":"Beløb","v":1000},"1/4 '01"]
[null,"1/4-01",{"$f":"Nyt_beløb_1*_1_4_2001","v":1456.9268},{"$f":"Nyt_beløb_2*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_3*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_4*_1_4_2001","v":1040.662},{"$f":"beløb_4_00/_1_4_2000*_1_4_2001","v":1021.7002647858396},{"$f":"Beløb","v":1000},"1/10 '01"]
[null,"1/10-01",{"$f":"Nyt_beløb_1*_1_10_2001","v":1471.6197999999999},{"$f":"Nyt_beløb_2*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_3*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_4*_1_10_2001","v":1051.1569999999999},{"$f":"beløb_4_00/_1_4_2000*_1_10_2001","v":1032.0040370759082},{"$f":"beløb_4_01/_1_4_2001*_1_10_2001","v":1010.0849267101133},{"$f":"Beløb","v":1000},"1/4 '02"]
[null,"1/4-02",{"$f":"Nyt_beløb_1*_1_4_2002","v":1486.1923999999999},{"$f":"Nyt_beløb_2*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_3*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_4*_1_4_2002","v":1061.566},{"$f":"beløb_4_00/_1_4_2000*_1_4_2002","v":1042.2233763581687},{"$f":"beløb_4_01/_1_4_2001*_1_4_2002","v":1020.0872137158848},{"$f":"beløb_10_01/_1_10_2001*_1_4_2002","v":1009.9024218075892},{"$f":"Beløb","v":1000},"1/4 '03"]
[null,"1/4-03",{"$f":"Nyt_beløb_1*_1_4_2003","v":1516.7908000000002},{"$f":"Nyt_beløb_2*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_3*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_4*_1_4_2003","v":1083.422},{"$f":"beløb_4_00/_1_4_2000*_1_4_2003","v":1063.6811416913504},{"$f":"beløb_4_01/_1_4_2001*_1_4_2003","v":1041.0892297403002},{"$f":"beløb_10_01/_1_10_2001*_1_4_2003","v":1030.6947487387708},{"$f":"beløb_4_02/_1_4_2002*_1_4_2003","v":1020.5884514010435},{"$f":"Beløb","v":1000},"1/8 '03"]
[null,"1/8-03",{"$f":"Nyt_beløb_1*_1_8_2003","v":1524.152},{"$f":"Nyt_beløb_2*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_3*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_4*_1_8_2003","v":1088.68},{"$f":"beløb_4_00/_1_4_2000*_1_8_2003","v":1068.8433365175706},{"$f":"beløb_4_01/_1_4_2001*_1_8_2003","v":1046.1417828267008},{"$f":"beløb_10_01/_1_10_2001*_1_8_2003","v":1035.6968559406446},{"$f":"beløb_4_02/_1_4_2002*_1_8_2003","v":1025.5415113144168},{"$f":"beløb_4_03/_1_4_2003*_1_8_2003","v":1004.853141250593},{"$f":"Beløb","v":1000},"1/10 '03"]
[null,"1/10-03",{"$f":"Nyt_beløb_1*_1_10_2003","v":1529.7450000000001},{"$f":"Nyt_beløb_2*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_3*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_4*_1_10_2003","v":1092.675},{"$f":"beløb_4_00/_1_4_2000*_1_10_2003","v":1072.7655442640043},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_02/_1_4_2002*_1_10_2003","v":1029.3048194836686},{"$f":"beløb_4_03/_1_4_2003*_1_10_2003","v":1008.5405317595545},{"$f":"beløb_8_03/_1_8_2003*_1_10_2003","v":1003.6695815115553},{"$f":"Beløb","v":1000},"1/4 '04"]
[null,"1/4 '04",{"$f":"Nyt_beløb_1*_1_4_2004","v":1553.3322000000001},{"$f":"Nyt_beløb_2*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_3*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_4*_1_4_2004","v":1109.5230000000001},{"$f":"beløb_4_00/_1_4_2000*_1_4_2004","v":1089.3065595611056},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_02/_1_4_2002*_1_4_2004","v":1045.1757121083381},{"$f":"beløb_4_03/_1_4_2003*_1_4_2004","v":1024.091258992341},{"$f":"beløb_8_03/_1_8_2003*_1_4_2004","v":1019.1452033655436},{"$f":"beløb_10_03/_1_10_2003*_1_4_2004","v":1015.4190404283066},{"$f":"Beløb","v":1000},"1/8 '04"]
[null,"1/8 '04",{"$f":"Nyt_beløb_1*_1_8_2004","v":1568.0532000000001},{"$f":"Nyt_beløb_2*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_3*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_4*_1_8_2004","v":1120.038},{"$f":"beløb_4_00/_1_4_2000*_1_8_2004","v":1099.6299674343854},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_02/_1_4_2002*_1_8_2004","v":1055.0808899305366},{"$f":"beløb_4_03/_1_4_2003*_1_8_2004","v":1033.7966184921481},{"$f":"beløb_8_03/_1_8_2003*_1_8_2004","v":1028.8036888709262},{"$f":"beløb_10_03/_1_10_2003*_1_8_2004","v":1025.0422129178392},{"$f":"beløb_4_04/_1_4_2004*_1_8_2004","v":1009.4770455411921},{"$f":"Beløb","v":1000},"1/10 '04"]
[null,"1/10 '04",{"$f":"Nyt_beløb_1*_1_10_2004","v":1574.2356},{"$f":"Nyt_beløb_2*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_3*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_4*_1_10_2004","v":1124.4540000000002},{"$f":"beløb_4_00/_1_4_2000*_1_10_2004","v":1103.9655042074146},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_02/_1_4_2002*_1_10_2004","v":1059.2407820144956},{"$f":"beløb_4_03/_1_4_2003*_1_10_2004","v":1037.8725925816534},{"$f":"beløb_8_03/_1_8_2003*_1_10_2004","v":1032.8599772201198},{"$f":"beløb_10_03/_1_10_2003*_1_10_2004","v":1029.0836708078798},{"$f":"beløb_4_04/_1_4_2004*_1_10_2004","v":1013.4571342820293},{"$f":"beløb_8_04/_1_8_2004*_1_10_2004","v":1003.9427233718856},{"$f":"Beløb","v":1000}]

{"sheet":"Tillæg_trin","index":6,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,1,7]]}
[3]
[]
[null,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[null,"Løngruppe",null,3]
[null,"Timer/uge",null,37]
[null,"Pensions-% inkl. evt. fritvalgs-%",null,13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",null,1.95]
[]
[null,"Stigning:","Fra","Til"]
[null,"Løntrin ",18,19]
[]
[null,"Løn",{"$f":"(VLOOKUP(til_trin,Lønark!A5:F61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE))/37*timetal*12","v":4547.0000000000146}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(VLOOKUP(til_trin,Lønark!L5:Q61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE))/37*timetal*pensionsstatus%*12","v":631.57830000000195}]
[null,"Ferietillæg",{"$f":"ferie_pct%*C13","v":88.666500000000283}]
[null,"Årlig bruttoudgift i alt",{"$f":"ROUND(SUM(C13:C15),0)","v":5267}]

{"sheet":"Tillæg_kr","index":7,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,1,9,2]]}
[2]
[]
[null,null,"Valgt lønniveau:",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[{"$f":"VLOOKUP(dummy,reg_procenter,2,FALSE)","v":{"$error":"#NAME?"}},null,"Årligt beløb, 31.3.2000 niveau ",12900]
[null,null,"Timer/uge",30]
[null,null,"Pension-% inkl. evt. fritvalgs-%",13.89]
[null,null,"Særlig feriegodtg., aktuel pct.",1.95]
[]
[]
[null,null,"bruttoudgift / år","bruttoudgift / md"]
[null,"Løn",{"$f":"kr*valgt_regulering/37*timetal","v":16715.879270270274},{"$f":"beløb/12","v":1392.9899391891895}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"beløb*pensionsstatus%","v":2321.8356306405408},{"$f":"C13/12","v":193.48630255337841}]
[null,"Ferietillæg",{"$f":"D8%*(C12)","v":325.95964577027036},{"$f":"C14/12","v":27.163303814189195}]
[null,"Bruttoudgift i alt",{"$f":"ROUND(SUM(C12:C14),0)","v":19364},{"$f":"ROUND(SUM(D12:D14),0)","v":1614}]

{"sheet":"Tid op_ned","index":8,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[null,"Grundoplysninger:"]
[null,"Løngruppe",4]
[null,"Pensions-% inkl. evt. fritvalgs-%",14.29]
[null,"Særlig feriegodtgørelse, aktuel procent",1.95]
[]
[]
[null,"Lønsammensætning (trin i alt og grundbeløb i alt)","Før ændring",null,"Efter ændring"]
[]
[null,"Løndele:","I alt"]
[]
[null,"Løntrin - centralt og lokalt aftalte",19,null,19]
[]
[null,"Tillæg (grundbeløb 31.3.2000) kr./år centralt og lokalt aftalte"]
[]
[]
[null,null,"Før ændring",null,"Efter ændring",null,null,{"$f":"\"Difference\"&IF(C24>E24,\" (lønnedgang)\",\" (lønstigning)\")","v":"Difference (lønstigning)"}]
[null,"Timer/uge",30,null,37,null,null,{"$f":"-(C19-timetal_ny)","v":7}]
[]
[null,"Fast månedsløn",{"$f":"(VLOOKUP(C13,Lønark!A5:F61,$C$4+2,FALSE)+((C15)*valgt_regulering/12))/37*C19","v":22603.04054054054},null,{"$f":"(VLOOKUP(E13,Lønark!A5:F61,$C$4+2,FALSE)+((E15)*valgt_regulering/12))/37*timetal_ny","v":27877.083333333332},null,null,{"$f":"E21-C21","v":5274.0427927927922}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(((VLOOKUP(C13,Lønark!L5:Q61,$C$4+2,FALSE)+(C15*valgt_regulering/12))/37*C19)*C5%)","v":3229.9744932432432},null,{"$f":"((VLOOKUP(E13,Lønark!L5:Q61,$C$4+2,FALSE)+(E15*valgt_regulering/12))/37*timetal_ny)*C5%","v":3983.6352083333331},null,null,{"$f":"E22-C22","v":753.66071509008998}]
[null,"Ferietillæg",{"$f":"$C$6%*C21","v":440.75929054054052},null,{"$f":"$C$6%*E21","v":543.60312499999998},null,null,{"$f":"E23-C23","v":102.84383445945946}]
[null,"Månedsløn, brutto",{"$f":"SUM(C21:C23)","v":26273.774324324324},null,{"$f":"SUM(E21:E23)","v":32404.321666666667},null,null,{"$f":"E24-C24","v":6130.5473423423427}]
[]
[null,"Fast løn, år",{"$f":"C21*12","v":271236.48648648651},0,334525,null,null,{"$f":"E26-C26","v":63288.513513513491}]
[null,"Pension inkl. evt. fritvalgstillæg, år",38759.693918918914,0,47803.622499999998,null,null,{"$f":"E27-C27","v":9043.9285810810834}]
[null,"Ferietillæg, år",{"$f":"C23*12","v":5289.1114864864867},null,{"$f":"E23*12","v":6523.2374999999993},null,null,{"$f":"E28-C28","v":1234.1260135135126}]
[null,"Årsløn, brutto",{"$f":"SUM(C26:C28)","v":315285.29189189192},null,{"$f":"SUM(E26:E28)","v":388851.86},null,null,{"$f":"E29-C29","v":73566.568108108069}]
[]
[null,"Timeløn",{"$f":"ROUND(VLOOKUP(C13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(C15*valgt_regulering/1924,2)","v":173.87},{"$f":"D26/timetal_ny*37/1924","v":0},{"$f":"ROUND(VLOOKUP(E13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(E15*valgt_regulering/1924,2)","v":173.87},null,null,{"$f":"E31-C31","v":0}]

{"sheet":"Samlet_omk","index":9,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-10-01"}]
[]
[null,"Løngruppe",0]
[null,"Timer/uge",37]
[null,"Pensions-% inkl. evt. fritvalgs-%",14.29]
[null,"Særlig feriegodtgørelse, aktuel pct.",1.95]
[]
[null,"Løntrin ",21]
[]
[null,"Reguleret tillæg (31.3.2000) kr./år",20800]
[]
[]
[null,"Løn/time",{"$f":"IFERROR(ROUND(VLOOKUP(fra_trin,Lønark!A5:AU61,løngruppe+43,FALSE)/1924,2)+ROUND(C10*valgt_regulering/1924,2),ROUND(C10*valgt_regulering/1924,2))","v":186.68}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C13*pensionsstatus%","v":26.676572}]
[null,"Ferietillæg",{"$f":"C6%*C13","v":3.6402600000000001}]
[null,"Time bruttoudgift i alt",{"$f":"SUM(C13:C15)","v":216.99683200000001}]
[]
[null,"Løn/måned",{"$f":"IFERROR((VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE)+(C10*valgt_regulering/12))/37*timetal,C10*valgt_regulering/12/37*timetal)","v":29930.725599999998}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"IFERROR(((VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE)+C10/12*valgt_regulering)/37*timetal)*pensionsstatus%,C10/12*valgt_regulering/37*timetal*pensionsstatus%)","v":4277.1006882399997}]
[null,"Ferietillæg",{"$f":"C6%*C18","v":583.64914920000001}]
[null,"Månedlig bruttoudgift i alt",{"$f":"SUM(C18:C20)","v":34791.47543744}]
[]
[null,"Løn/år",{"$f":"C18*12","v":359168.70719999995}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C19*12","v":51325.208258879997}]
[null,"Ferietillæg",{"$f":"C20*12","v":7003.7897904000001}]
[null,"Årlig bruttoudgift i alt",{"$f":"SUM(C23:C25)","v":417497.70524927997}]